Attach Related Record

This trigger attaches the current record to a related record (i.e. establishes a relationship between two records). To use this trigger, select or define:

• A relationship between current object and a target object.
• A formula that calculates the ID or array of IDs of the related record (instead of a condition formula). If this formula returns a null or negative number, this trigger is ignored.

The following formula example uses the query API to determine the ID of the record to be attached:

var arr = rbv_api.selectQuery("SELECT id FROM contact WHERE status=?", 'Ready');
   var ids = new Array();
   for (var k=0; k<arr.length; k++) {
    ids[k] = arr[k][0];
    }
    return ids;